select * from production.product

update production.product
set color='Blue'
where ProductId=316

update Production.Product
set Name='Half-Finger Gloves, M'
where ProductID=859



SELECT Production.Product.ProductID,  
        Production.Product.Name,  
        Production.Location.Name AS Location,  
        Production.ProductInventory.Quantity  
        FROM Production.Product INNER JOIN  
        Production.ProductInventory  
        ON Production.Product.ProductID =  
        Production.ProductInventory.ProductID  
        INNER JOIN Production.Location  
        ON Production.ProductInventory.LocationID =  
        Production.Location.LocationID  
        WHERE ( Production.ProductInventory.Quantity <= 100 )  
        ORDER BY Production.ProductInventory.Quantity,  
        Production.Product.Name
        
        
        
        SELECT * FROM Production.Product WHERE Name LIKE 'HL Road Frame - Black, 58'
        
        UPDATE production.Product
        SET name='HL Road Frame - Black, 58 mod' 
        WHERE ProductID=680